package com.peenongsaban.freelance.utils;

public class ConstantUtils {
	
	//Configuration Database
	public static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
//	public static final String URL = "jdbc:mysql://db4free.net:3306/freelance?useUnicode=true&characterEncoding=utf-8";
//	public static final String USER = "wittayayon";
//	public static final String PASSWORD = "Peenongsaban1634";
	public static final String URL = "jdbc:mysql://localhost:3306/freelance_db?useUnicode=true&characterEncoding=utf-8";
	public static final String USER = "root";
	public static final String PASSWORD = "123456";
	public static final int MAX_CONNECTION = 5;
	
	//Format Time 
	public static final String FORMAT_TIME_HOUR = "รายชั่วโมง";
	public static final String FORMAT_TIME_DAY = "รายวัน";
	public static final String FORMAT_TIME_MONTH = "รายเดือน";
	public static final String FORMAT_TIME_PACKAGE = "เหมาจ่าย";
	public static final String FORMAT_TIME_BID = "เสนอราคา";
	
	
	//Job
	public static final String POST_JOB_URGENT_CODE = "1";
	public static final int LIMIT_PAGING_LIST_JOB = 10;
	public static final int LIMIT_PAGING_MY_POST_JOB =10;
	public static final int LIMIT_PAGING_MY_REQUEST_JOB =10;
	public static final int LIMIT_LIST_LAST_JOB =19;
	public static final String POST_JOB_STATUS_OF_POST_DEFAULT = "O";
	
	
	//Service
	public static final int LIMIT_PAGING_MY_POST_SERVICE =2;
	public static final int LIMIT_PAGING_MY_REQUEST_SERVICE =1;
	
	//Status Of Request Job
	public static final int STATUS_REQUEST_OF_REQUEST_JOB =1;
	public static final int STATUS_APPROVED_OF_REQUEST_JOB =2;
	public static final int STATUS_DISAPPROVED_OF_REQUEST_JOB =3;
	public static final int STATUS_WORKING_OF_REQUEST_JOB =4;
	public static final int STATUS_WAITING_ESTIMATE_OF_REQUEST_JOB =5;
	public static final int STATUS_SUCCESS_OF_REQUEST_JOB =6;
	public static final int STATUS_CANCLE_OF_REQUEST_JOB =7;
	public static final int STATUS_CONFIRM_OF_REQUEST_JOB =8;
	public static final int STATUS_NOT_CONFIRM_OF_REQUEST_JOB =9;
	public static final int STATUS_WAITING_APPROVE_OF_REQUEST_JOB =10;
	public static final int STATUS_WAITING_CONFIRM_OF_REQUEST_JOB =11;
	public static final int STATUS_ESTIMATE_OF_REQUEST_JOB =12;
	public static final int STATUS_REQUEST_FREELANCE =13;

	//Status authorize job
	public static final String STATUS_AUTHORIZE_JOB_POST = "P";
	public static final String STATUS_AUTHORIZE_REQUEST_JOB = "R";
	public static final String STATUS_AUTHORIZE_APPROVED_REQUEST_JOB = "A";
	public static final String STATUS_AUTHORIZE_DISAPPROVED_REQUEST_JOB = "D";
	public static final String STATUS_AUTHORIZE_CONFIRM_JOB = "C";
	public static final String STATUS_AUTHORIZE_NOT_CONFIRM_JOB = "N";
	public static final String STATUS_AUTHORIZE_WORKING_JOB = "W";
	public static final String STATUS_AUTHORIZE_ESTIMATE_JOB = "E";
	public static final String STATUS_AUTHORIZE_SUCCESS_JOB = "S";

	
	public static final String STATUS_ACTIVE = "A";
	public static final String STATUS_INACTIVE = "I";
	
	public static final String FREELANE = "Freelance";
	public static final String OWNER_JOB = "OwnerJob";
	
//	public static final String SESSION_USERNAME = "session_userName";
//	public static final String SESSION_IDCARD = "session_idCard";
//	public static final String SESSION_NAME_TH = "session_name_th";
//	public static final String SESSION_NAME_EN = "session_name_en";
//	public static final String SESSION_LASTNAME_TH = "session_lastName_th";
//	public static final String SESSION_LASTNAME_EN = "session_lastName_en";
//	public static final String SESSION_PICTURE_PROFILE = "session_pictrue_profile";
	public static final String SESSION_LOGIN = "session_login";

	
	public static final String DUMMY_ID = "dummy_id";
	
	public static final String EMPTY_STRING = "";
	public static final String NULL = null;

	
	public static final String LOGIN_HISTORY_TYPE_ID = "1";
	public static final String LOGIN_NOTE = "Login";
	
	
	public static final String YES = "y";
	public static final String NO = "n";
	
}
